package com.stylefeng.guns.modular.apple_id_manage.dao;

import com.stylefeng.guns.modular.apple_id_manage.model.AppleIds;
import com.baomidou.mybatisplus.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * <p>
 * 苹果账号表 Mapper 接口
 * </p>
 *
 * @author godrui
 * @since 2020-06-20
 */
public interface AppleIdsMapper extends BaseMapper<AppleIds> {
    //批量插入苹果账号
    void insertForEach(@Param("listValue") List<AppleIds> appleIds);
    //查询可用设备数量
    Integer findEnableDeviceCount();
    List<AppleIds> findUnUsedAccount(@Param("start") Integer start,
                                     @Param("count") Integer count);
    Integer findUnUsedCount();
    List<AppleIds> findUsedAccount(@Param("start") Integer start,
                                     @Param("count") Integer count);
    Integer findUsedCount();
    List<AppleIds> findBlockedAccount(@Param("start") Integer start,
                                     @Param("count") Integer count);
    Integer findBlockedCount();
}
